package com.flyu.dao.Provider;

import com.flyu.pojo.Provider;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

public interface ProviderDao {
    // 获取供应商列表
    public List<Provider> getProviderList(Connection connection) throws SQLException;
    // 根据检索条件返回供应商列表
    public List<Provider> getProviderListByRule(Connection connection, String providerCode, String providerName, int currentPageNo, int pageSize) throws SQLException;
    // 统计符合条件的供应商数量
    public int getProviderCount(Connection connection, String providerCode, String providerName) throws SQLException;
    // 添加供应商
    public int addProvider(Connection connection, Provider provider) throws SQLException;
    // 删除供应商
    public int delProvider(Connection connection, int proId) throws SQLException;
    // 根据id返回对应provider
    public Provider getProviderById(Connection connection, int proid) throws SQLException;
    // 保存修改
    public int modifySave(Connection connection, Provider provider) throws SQLException;
}
